package com.game.springbootstart.mapper;

import org.apache.ibatis.annotations.Mapper;
import com.game.springbootstart.entity.GamesDetails;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * <p>
 * 游戏申请表 Mapper 接口
 * </p>
 *
 * @author author
 * @since 2025-02-24
 */
@Mapper
public interface GamesDetailsMapper extends BaseMapper<GamesDetails> {

    @Update("update game.games_details set status = 0 WHERE id = #{id}")
    void setStatus(Integer id);

    @Select("select game_url from game.games_details where id = #{id}")
    String getGameUrl(Long id);
}


